3 articles tagged with ""databases""
I built our e-commerce product listing with OFFSET pagination and it worked great — until we hit 500K products and every page-10 query started taking 4 seconds. Here's the pagination strategy that saved our backend.
I spent three years cramming search, sessions, blob storage, and real-time feeds into PostgreSQL. Then I discovered polyglot persistence, and my database stopped looking like a hoarder's garage. Here's what I learned the hard way.
Coming from Laravel's Eloquent where your SQL errors hide until a user hits that route at 3am, discovering that Rust's SQLx can verify your SQL queries at compile time felt like being handed a superpower I didn't know I needed.